
  create external table jms_dim.dim_tab_delivery_white_list_cfg_base
(
  id                   string,
  type_name            string comment '类型名称',
  type_code            string comment '类型编码',
  customer_name        string comment '客户名称',
  customer_code        string comment '客户编码',
  neteork_code         string comment '网点编码',
  neteork_name         string comment '网点名称',
  agent_code           string comment '代理区编码',
  agent_name           string comment '代理区名称',
  status               tinyint comment '状态',
  create_by_name       string comment '创建人名称',
  create_by_code       string comment '创建人code',
  create_time          TIMESTAMP comment '创建时间',
  update_time          TIMESTAMP comment '更新时间',
  update_by_name       string comment '修改人名称',
  update_by_code       string comment '修改人code',
  remark               string comment '备注(预留字段)'
)comment '出港交件白名单配置表'
ROW FORMAT SERDE
  'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
STORED AS INPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
OUTPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION
  '/dw/hive/jms_dim.db/external/dim_tab_delivery_white_list_cfg_base';